package com.example.demo.mapper;


import com.example.demo.entity.Comment;
import org.apache.ibatis.annotations.*;

import javax.swing.plaf.SpinnerUI;

@Mapper
public interface CommentMapper {
    @Select(("SELECT * FROM t_comment WHERE id=#{id}"))
    public Comment findByid(Integer id);
    @Insert("INSERT INTO t_comment(a_id,author,content) VALUES (#{aId},#{author}, #{content} )")
    public int insertComment(Comment comment);
    @Update("UPDATE t_comment SET content=#{content} WHERE id=#{id}")
    public   int updateComment(Comment comment);
    @Delete("DELETE FROM t_comment WHERE id=#(id)")
    public int deleteComment(Integer id);
}
